--
-- PostgreSQL database dump
--

-- Dumped from database version 12.22
-- Dumped by pg_dump version 12.22

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

DROP DATABASE IF EXISTS mindcare_db;
--
-- Name: mindcare_db; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE mindcare_db WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'Chinese (Simplified)_China.936' LC_CTYPE = 'Chinese (Simplified)_China.936';


ALTER DATABASE mindcare_db OWNER TO postgres;

\connect mindcare_db

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: pgcrypto; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public;


--
-- Name: EXTENSION pgcrypto; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION pgcrypto IS 'cryptographic functions';


--
-- Name: uuid-ossp; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;


--
-- Name: EXTENSION "uuid-ossp"; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally unique identifiers (UUIDs)';


--
-- Name: update_timestamp(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.update_timestamp() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
BEGIN
    NEW.update_time = CURRENT_TIMESTAMP;
    RETURN NEW;
END;
$$;


ALTER FUNCTION public.update_timestamp() OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: conversation_records; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.conversation_records (
    id integer NOT NULL,
    user_id uuid NOT NULL,
    conversation_id character varying(64) NOT NULL,
    role character varying(10) NOT NULL,
    content text NOT NULL,
    message_id character varying(64) NOT NULL,
    parent_message_id character varying(64),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    model_metadata text,
    CONSTRAINT conversation_records_role_check CHECK (((role)::text = ANY ((ARRAY['user'::character varying, 'ai'::character varying])::text[])))
);


ALTER TABLE public.conversation_records OWNER TO postgres;

--
-- Name: TABLE conversation_records; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.conversation_records IS '存储会话的具体消息记录';


--
-- Name: COLUMN conversation_records.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversation_records.id IS '自增ID（内部使用）';


--
-- Name: COLUMN conversation_records.user_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversation_records.user_id IS '关联的用户ID，格式：usr_UUID';


--
-- Name: COLUMN conversation_records.conversation_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversation_records.conversation_id IS '关联的会话ID，格式：conv_UUID';


--
-- Name: COLUMN conversation_records.role; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversation_records.role IS '消息发送方角色';


--
-- Name: COLUMN conversation_records.content; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversation_records.content IS '消息内容';


--
-- Name: COLUMN conversation_records.message_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversation_records.message_id IS '消息ID，格式：msg_自增ID';


--
-- Name: COLUMN conversation_records.parent_message_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversation_records.parent_message_id IS '父消息ID';


--
-- Name: COLUMN conversation_records.created_at; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversation_records.created_at IS '消息创建时间';


--
-- Name: COLUMN conversation_records.model_metadata; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversation_records.model_metadata IS '处理消息的模型';


--
-- Name: conversation_records_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.conversation_records_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.conversation_records_id_seq OWNER TO postgres;

--
-- Name: conversation_records_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.conversation_records_id_seq OWNED BY public.conversation_records.id;


--
-- Name: conversations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.conversations (
    id character varying(64) NOT NULL,
    user_id uuid NOT NULL,
    topic character varying(256),
    start_time timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    last_active_time timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    persona character varying(64) DEFAULT 'professional'::character varying NOT NULL
);


ALTER TABLE public.conversations OWNER TO postgres;

--
-- Name: TABLE conversations; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.conversations IS '存储会话基本信息';


--
-- Name: COLUMN conversations.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversations.id IS '会话ID，格式：conv_UUID';


--
-- Name: COLUMN conversations.user_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversations.user_id IS '关联的用户ID，格式：usr_UUID';


--
-- Name: COLUMN conversations.topic; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversations.topic IS '会话标题';


--
-- Name: COLUMN conversations.start_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversations.start_time IS '会话开始时间';


--
-- Name: COLUMN conversations.last_active_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversations.last_active_time IS '会话最后活跃时间';


--
-- Name: COLUMN conversations.persona; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.conversations.persona IS '会话人设';


--
-- Name: emotion_records; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.emotion_records (
    id integer NOT NULL,
    user_id uuid NOT NULL,
    emotion character varying(10) NOT NULL,
    content text NOT NULL,
    summary text,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    ai_response text,
    image_url character varying(256)
);


ALTER TABLE public.emotion_records OWNER TO postgres;

--
-- Name: TABLE emotion_records; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.emotion_records IS '用户情绪记录表，存储用户情绪记录及AI反馈';


--
-- Name: COLUMN emotion_records.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.emotion_records.id IS '自增整数主键，适合单机高性能场景';


--
-- Name: COLUMN emotion_records.user_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.emotion_records.user_id IS '关联users表的UUID类型用户ID，外键约束';


--
-- Name: COLUMN emotion_records.ai_response; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.emotion_records.ai_response IS 'AI根据情绪和内容生成的回复与建议，合并存储';


--
-- Name: emotion_records_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.emotion_records ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.emotion_records_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: mood_records; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.mood_records (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    user_id uuid NOT NULL,
    emotion character varying(10) DEFAULT ''::character varying,
    content text DEFAULT ''::text,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    summary text DEFAULT ''::text,
    image_url character varying(256) DEFAULT ''::character varying,
    ai_response text
);


ALTER TABLE public.mood_records OWNER TO postgres;

--
-- Name: psychological_assessment_records; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.psychological_assessment_records (
    id integer NOT NULL,
    user_id uuid NOT NULL,
    assessment_name character varying(100) NOT NULL,
    results text NOT NULL,
    ai_response text,
    assessment_time timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.psychological_assessment_records OWNER TO postgres;

--
-- Name: TABLE psychological_assessment_records; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.psychological_assessment_records IS '存储用户心理测评记录，包括MBTI、SDS等测评结果';


--
-- Name: COLUMN psychological_assessment_records.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.psychological_assessment_records.id IS '自增主键，用于唯一标识每条测评记录';


--
-- Name: COLUMN psychological_assessment_records.user_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.psychological_assessment_records.user_id IS '关联用户表的UUID类型ID，外键约束，用户删除时级联删除记录';


--
-- Name: COLUMN psychological_assessment_records.assessment_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.psychological_assessment_records.assessment_name IS '测评问卷名称，如''MBTI测试''、''SDS抑郁自评量表''';


--
-- Name: COLUMN psychological_assessment_records.results; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.psychological_assessment_records.results IS '测评结果，存储为JSON格式的字符串（如MBTI类型、SDS分数等）';


--
-- Name: COLUMN psychological_assessment_records.ai_response; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.psychological_assessment_records.ai_response IS 'AI根据测评结果生成的回复或建议';


--
-- Name: COLUMN psychological_assessment_records.assessment_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.psychological_assessment_records.assessment_time IS '测评完成时间，默认使用服务器当前时间';


--
-- Name: psychological_assessment_records_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.psychological_assessment_records_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.psychological_assessment_records_id_seq OWNER TO postgres;

--
-- Name: psychological_assessment_records_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.psychological_assessment_records_id_seq OWNED BY public.psychological_assessment_records.id;


--
-- Name: user_buffers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.user_buffers (
    id integer NOT NULL,
    user_id uuid NOT NULL,
    conversation_id character varying(64) NOT NULL,
    role character varying(10) NOT NULL,
    content text NOT NULL,
    message_id character varying(64) NOT NULL,
    parent_message_id character varying(64),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    model_metadata text
);


ALTER TABLE public.user_buffers OWNER TO postgres;

--
-- Name: user_buffers_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.user_buffers_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_buffers_id_seq OWNER TO postgres;

--
-- Name: user_buffers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.user_buffers_id_seq OWNED BY public.user_buffers.id;


--
-- Name: users; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.users (
    phone character varying(11) NOT NULL,
    password_hash character varying(128),
    email character varying(128),
    created_at timestamp with time zone DEFAULT now(),
    id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    avatar_url character varying(256),
    nickname character varying(64),
    gender character(10),
    signature text,
    long_term_memory text
);


ALTER TABLE public.users OWNER TO postgres;

--
-- Name: conversation_records id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversation_records ALTER COLUMN id SET DEFAULT nextval('public.conversation_records_id_seq'::regclass);


--
-- Name: psychological_assessment_records id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.psychological_assessment_records ALTER COLUMN id SET DEFAULT nextval('public.psychological_assessment_records_id_seq'::regclass);


--
-- Name: user_buffers id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_buffers ALTER COLUMN id SET DEFAULT nextval('public.user_buffers_id_seq'::regclass);


--
-- Data for Name: conversation_records; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.conversation_records (id, user_id, conversation_id, role, content, message_id, parent_message_id, created_at, model_metadata) FROM stdin;
37	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	您好，我是心研助手。作为心理学与AI结合的研究型智能体，我会以专业视角陪伴您探索情绪需求。	msg_37	\N	2025-06-18 20:41:03.822744+08	
38	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	你会编程吗	msg_38	msg_37	2025-06-18 20:41:22.369881+08	
39	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	你好呀	msg_39	msg_38	2025-06-18 20:43:39.281932+08	
40	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	代码总是报错是什么原因	msg_40	msg_39	2025-06-18 20:47:43.412883+08	
41	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	代码总是报错是什么原因	msg_41	msg_40	2025-06-18 20:50:09.197179+08	
42	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	您好，我注意到您在技术问题上遇到了一些困扰。作为心理陪伴助手，我观察到重复询问同一个技术问题可能反映出某种焦虑情绪。🤔\n\n从心理学角度看，当我们在某个领域反复遇到障碍时，往往会产生"习得性无助感"。建议您可以：\n1. 先暂停5分钟进行深呼吸（4-7-8呼吸法）\n2. 将大问题拆解成小步骤\n\n您愿意和我聊聊写代码时具体的情绪体验吗？比如当看到报错信息时，身体会有什么感觉？🧐	msg_42	msg_41	2025-06-18 20:50:16.274249+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
43	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	写代码的时候想着快点写完	msg_43	msg_42	2025-06-18 20:51:21.077596+08	
44	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	我注意到您提到"想快点写完"时，这种时间压力可能触发了心理学上的"时间紧迫感"现象⏳。根据耶克斯-多德森定律，适度的紧迫感能提升效率，但过度时反而会影响认知功能。\n\n建议您可以：\n1. 尝试"番茄工作法"（25分钟专注+5分钟休息）\n2. 用便利贴把"完美主义"暂时贴到墙上（具象化抽离技巧）\n\n您平时会用什么方式来缓解这种编程时的急切感呢？比如听某种特定音乐或调整工作环境？🎵\n\n（运用心理学理论解释现象，提供两种具体干预方案，最后以开放式提问引导自我觉察）	msg_44	msg_43	2025-06-18 20:51:29.971741+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
45	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	是这样的	msg_45	msg_44	2025-06-18 21:22:28.662898+08	{}
46	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	是这样的	msg_46	msg_45	2025-06-18 21:25:02.807384+08	{}
47	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	我理解您对当前状态的认同，这反映出您开始觉察到自己的编程状态了🧠。从心理学角度看，这种"是这样的"的确认回应，其实是一种重要的自我认知信号。\n\n让我们尝试用"认知解离"技术来观察这个状态：\n1️⃣ 想象把"急切感"放在房间的沙发上（具象化技术）\n2️⃣ 问自己："如果朋友处在这种状态，我会给他什么建议？"（视角转换法）\n\n您注意到"想快点写完"这个念头时，身体哪个部位最先感受到紧张呢？🤔（引导躯体觉察）\n\n（运用具象化+视角转换两种技术，保持1提问+2支持点的专业结构）	msg_47	msg_46	2025-06-18 21:25:12.522172+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
48	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	哎呀好烦	msg_48	msg_47	2025-06-18 21:45:01.94373+08	{}
49	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	哎呀好烦	msg_49	msg_48	2025-06-18 21:47:46.743975+08	{}
50	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	哎呀好烦	msg_50	msg_49	2025-06-18 21:49:21.530622+08	{}
51	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	哎呀好烦	msg_51	msg_50	2025-06-18 21:51:24.915482+08	{}
52	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	我注意到您反复表达了"好烦"的情绪，这种重复实际上是一种很重要的心理信号📶。从情绪调节理论来看，重复表达往往是深层压力需要释放的表现。\n\n让我们试试"情绪容器"技术：\n1️⃣ 想象面前有个透明容器，把"烦"的情绪具象成某种颜色/质地的物体（情绪外化）\n2️⃣ 观察这个物体在容器中的变化（静观技术）\n\n您愿意描述一下这个"烦"在身体里是什么感觉吗？比如是发热的、沉重的还是刺痛的？🧠（引导躯体化觉察）\n\n（运用情绪外化+静观技术，保持专业陪伴结构）	msg_52	msg_51	2025-06-18 21:51:34.985685+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
53	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	ai	您好，我是心研助手。作为心理学与AI结合的研究型智能体，我会以专业视角陪伴您探索情绪需求。	msg_53	\N	2025-06-22 19:34:12.695642+08	{}
54	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	user	我现在很不舒服	msg_54	msg_53	2025-06-22 19:34:46.849631+08	{}
55	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	ai	我注意到您用了"很不舒服"这样的整体性描述（情绪识别），这种弥散性的负面感受确实会让人困扰（共情反馈）✨\n\n从心理学角度看，我们可以先做个简单的"情绪定位"（专业引导）：\n1. 这种不适更多是身体上的紧绷/疼痛，还是心理上的压抑/焦虑？（区分生理心理）\n2. 如果用0-10分评估强度，您现在的感受大概在哪个区间？（量化评估）\n\n根据压力研究的ABC理论，当我们能清晰定义不适的维度时（认知心理学应用），往往就找到了调节的突破口🌱\n\n您愿意选择一个维度先聊聊吗？（给予掌控感）	msg_55	msg_54	2025-06-22 19:34:56.547513+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
56	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	user	目前比较焦虑	msg_56	msg_55	2025-06-22 19:36:32.291098+08	{}
58	ea92595b-0c01-4b71-b017-24af94274c3f	conv_ba257234-a094-4c8a-8fb2-27a6a900c94f	ai	您好，我是心研助手。作为心理学与AI结合的研究型智能体，我会以专业视角陪伴您探索情绪需求。	msg_58	\N	2025-06-22 21:02:01.08245+08	{}
59	ea92595b-0c01-4b71-b017-24af94274c3f	conv_ba257234-a094-4c8a-8fb2-27a6a900c94f	user	好吧	msg_59	msg_58	2025-06-22 21:02:59.094961+08	{}
57	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	ai	我理解您正在经历焦虑的困扰（情绪确认），这种感受就像大脑的预警系统被过度激活（神经心理学解释）🧠\n\n根据焦虑认知模型（专业理论引用），我们可以从两个层面来梳理：\n1. 触发因素：最近是否遇到某些具体事件引发了这种焦虑？（情境探索）\n2. 身体信号：您注意到心跳加快/呼吸变化等生理反应了吗？（身心联结引导）\n\n研究显示（数据支持），当人们能用具体词汇描述焦虑时（如"截止日期焦虑"vs"社交场合焦虑"），焦虑强度平均会降低23%（Journal of Anxiety Disorders, 2021）📊\n\n您愿意尝试用1-2个关键词来形容当前的焦虑类型吗？（结构化引导）	msg_57	msg_56	2025-06-22 19:36:40.910642+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
60	ea92595b-0c01-4b71-b017-24af94274c3f	conv_ba257234-a094-4c8a-8fb2-27a6a900c94f	ai	我注意到您似乎有些欲言又止（情绪觉察）。或许我们可以先聊聊您今天的状态？就像调整显微镜焦距一样（专业比喻🔬），慢慢找到最适合交流的切入点。\n\n您更倾向于：\n1. 分享具体的生活事件\n2. 探讨某种模糊的感受\n3. 寻求应对压力的方法建议\n\n（采用选项式提问降低表达压力，同时保持专业框架）	msg_60	msg_59	2025-06-22 21:03:05.044892+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
\.


--
-- Data for Name: conversations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.conversations (id, user_id, topic, start_time, last_active_time, persona) FROM stdin;
conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ea92595b-0c01-4b71-b017-24af94274c3f	编程焦虑	2025-06-18 20:41:03.787944+08	2025-06-18 20:41:03.787944+08	professional
conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	ea92595b-0c01-4b71-b017-24af94274c3f	心理疏导	2025-06-22 19:34:12.678924+08	2025-06-22 19:34:12.678924+08	professional
conv_ba257234-a094-4c8a-8fb2-27a6a900c94f	ea92595b-0c01-4b71-b017-24af94274c3f	心理陪伴	2025-06-22 21:02:01.073443+08	2025-06-22 21:02:01.073443+08	professional
\.


--
-- Data for Name: emotion_records; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.emotion_records (id, user_id, emotion, content, summary, created_at, ai_response, image_url) FROM stdin;
2	4bdec59e-74c5-4227-8e5f-fe2f5ab454c5	受伤	今天是6月20日，下了一天雨，下雨天睡觉很舒服	受伤情绪｜雨天舒适睡眠完成两项任务	2025-06-20 16:36:33.375059+08	雨天确实适合惬意休息呢~为高效完成事项点赞，要保留这份舒适感哦	
\.


--
-- Data for Name: mood_records; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.mood_records (id, user_id, emotion, content, created_at, summary, image_url, ai_response) FROM stdin;
9258eb75-1964-4d15-b331-27fd4858de48	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-17 11:37:26.915868+08			\N
ec15a194-0d03-42b2-9b54-0f27656bcfa9	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-02 11:37:26.915868+08			\N
6b49ca65-ee78-404b-9135-6a0adcebc168	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-03 11:37:26.915868+08			\N
b9797975-9768-4c01-9266-d6440c0c9442	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-04 11:37:26.915868+08			\N
2c135466-7c5c-4171-8b11-e5d605b4a006	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-05 11:37:26.915868+08			\N
4628de2b-380e-4779-aece-c8be30b3eb92	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-06 11:37:26.915868+08			\N
fb7b6aca-a915-4bbb-941f-d8a698abda24	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-07 11:37:26.915868+08			\N
80947512-56e7-4dc3-8f42-c968ae9a168c	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-08 11:37:26.915868+08			\N
29ad5af0-e779-4e2a-98ec-d46f028aec13	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-09 11:37:26.915868+08			\N
70e32f31-1920-47fe-945b-e918aafe00f7	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-10 11:37:26.915868+08			\N
2a7f38d0-61eb-444a-925c-18a6917cf842	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-11 11:37:26.915868+08			\N
4b5305f4-3b84-4503-965e-6ae29f515ef7	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-12 11:37:26.915868+08			\N
cdddacae-159f-48d3-afbb-046e154d7b39	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-13 11:37:26.915868+08			\N
cf6927c1-3938-46e4-8cd8-6319e81b2c26	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-14 11:37:26.915868+08			\N
e7a613f9-0c49-4d1b-8de1-3648791f72c8	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-15 11:37:26.915868+08			\N
2eecd658-6fd9-41ca-9554-4f90c69ac3f2	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-16 11:37:26.915868+08			\N
982bb99a-d6ce-4e6e-b346-5692e92f91fd	ea92595b-0c01-4b71-b017-24af94274c3f	平静		2025-05-18 11:37:26.915868+08			\N
333e904a-dded-424c-98e3-94398c47ed49	ea92595b-0c01-4b71-b017-24af94274c3f	平静	今天是真的累	2025-05-25 14:56:17.573662+08			\N
2a295290-f1ef-45a8-ac1d-bb90fb2e6ca9	ea92595b-0c01-4b71-b017-24af94274c3f	平静	元气满满的一天呢	2025-05-25 11:37:26.915868+08			\N
e2f35161-85a2-4463-9aed-b67edf21c41a	ea92595b-0c01-4b71-b017-24af94274c3f	抑郁	活人微死，emo中	2025-05-19 11:37:26.915868+08			\N
07dbccbe-2b01-43a2-9a39-7574336d1a01	ea92595b-0c01-4b71-b017-24af94274c3f	焦虑	好想毕业啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊	2025-05-21 11:37:26.915868+08			\N
220000df-46fc-452c-806e-9af3534167df	ea92595b-0c01-4b71-b017-24af94274c3f	平静	元气满满的一天呢	2025-05-20 11:37:26.915868+08			\N
\.


--
-- Data for Name: psychological_assessment_records; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.psychological_assessment_records (id, user_id, assessment_name, results, ai_response, assessment_time) FROM stdin;
2	4bdec59e-74c5-4227-8e5f-fe2f5ab454c5	SDS	{"raw_score": 50, "standard_score": 62, "depression_level": "\\u8f7b\\u5ea6\\u6291\\u90c1", "interpretation": "\\u60a8\\u7684\\u6807\\u51c6\\u5206\\u4e3a62\\uff0c\\u5c5e\\u4e8e\\u8f7b\\u5ea6\\u6291\\u90c1\\u3002\\u5efa\\u8bae\\u4fdd\\u6301\\u826f\\u597d\\u7684\\u751f\\u6d3b\\u4e60\\u60ef\\uff0c\\u9002\\u5f53\\u8c03\\u6574\\u5fc3\\u6001\\uff0c\\u5fc5\\u8981\\u65f6\\u53ef\\u5bfb\\u6c42\\u4e13\\u4e1a\\u5e2e\\u52a9\\u3002"}		2025-06-20 17:07:03.470272+08
1	4bdec59e-74c5-4227-8e5f-fe2f5ab454c5	MBTI	{"mbti_type": "INFP", "description": "\\u7406\\u60f3\\u4e3b\\u4e49\\uff0c\\u5bf9\\u4e8e\\u81ea\\u5df1\\u7684\\u4ef7\\u503c\\u89c2\\u548c\\u81ea\\u5df1\\u89c9\\u5f97\\u91cd\\u8981\\u7684\\u4eba\\u975e\\u5e38\\u5fe0\\u8bda\\u3002\\u5e0c\\u671b\\u5916\\u90e8\\u7684\\u751f\\u6d3b\\u548c\\u81ea\\u5df1\\u5185\\u5fc3\\u7684\\u4ef7\\u503c\\u89c2\\u662f\\u7edf\\u4e00\\u7684\\u3002\\u597d\\u5947\\u5fc3\\u91cd\\uff0c\\u5f88\\u5feb\\u80fd\\u770b\\u5230\\u4e8b\\u60c5\\u7684\\u53ef\\u80fd\\u6027\\uff0c\\u80fd\\u6210\\u4e3a\\u5b9e\\u73b0\\u60f3\\u6cd5\\u7684\\u50ac\\u5316\\u5242\\u3002\\u5bfb\\u6c42\\u7406\\u89e3\\u522b\\u4eba\\u548c\\u5e2e\\u52a9\\u4ed6\\u4eec\\u5b9e\\u73b0\\u6f5c\\u80fd\\u3002\\u9002\\u5e94\\u529b\\u5f3a\\uff0c\\u7075\\u6d3b\\uff0c\\u5584\\u4e8e\\u627f\\u53d7\\uff0c\\u9664\\u975e\\u662f\\u6709\\u6096\\u4e8e\\u81ea\\u5df1\\u7684\\u4ef7\\u503c\\u89c2\\u7684\\u3002"}		2025-06-20 17:02:40.060845+08
3	ea92595b-0c01-4b71-b017-24af94274c3f	SAS	{"raw_score": 50, "standard_score": 62, "anxiety_level": "\\u4e2d\\u5ea6\\u7126\\u8651", "interpretation": "\\u60a8\\u7684\\u7126\\u8651\\u6c34\\u5e73\\u9002\\u4e2d\\uff0c\\u53ef\\u80fd\\u9700\\u8981\\u4e13\\u4e1a\\u5fc3\\u7406\\u5e72\\u9884\\u6216\\u54a8\\u8be2\\u6765\\u6539\\u5584\\u3002"}		2025-06-20 18:41:08.512632+08
4	ea92595b-0c01-4b71-b017-24af94274c3f	贝克抑郁测试	{"total_score": 50, "depression_level": "\\u4e25\\u91cd\\u6291\\u90c1", "interpretation": "\\u60a8\\u7684\\u6291\\u90c1\\u7a0b\\u5ea6\\u8f83\\u4e25\\u91cd\\uff0c\\u5fc5\\u987b\\u5c3d\\u5feb\\u770b\\u5fc3\\u7406\\u533b\\u751f\\u8fdb\\u884c\\u5e72\\u9884\\u6cbb\\u7597\\u3002"}		2025-06-20 18:58:51.489978+08
5	ea92595b-0c01-4b71-b017-24af94274c3f	贝克抑郁测试	{"total_score": 50, "depression_level": "\\u4e25\\u91cd\\u6291\\u90c1", "interpretation": "\\u60a8\\u7684\\u6291\\u90c1\\u7a0b\\u5ea6\\u8f83\\u4e25\\u91cd\\uff0c\\u5fc5\\u987b\\u5c3d\\u5feb\\u770b\\u5fc3\\u7406\\u533b\\u751f\\u8fdb\\u884c\\u5e72\\u9884\\u6cbb\\u7597\\u3002"}		2025-06-20 18:59:12.495259+08
6	ea92595b-0c01-4b71-b017-24af94274c3f	SAS	{"raw_score": 50, "standard_score": 62, "anxiety_level": "\\u4e2d\\u5ea6\\u7126\\u8651", "interpretation": "\\u60a8\\u7684\\u7126\\u8651\\u6c34\\u5e73\\u9002\\u4e2d\\uff0c\\u53ef\\u80fd\\u9700\\u8981\\u4e13\\u4e1a\\u5fc3\\u7406\\u5e72\\u9884\\u6216\\u54a8\\u8be2\\u6765\\u6539\\u5584\\u3002"}		2025-06-20 18:59:19.32496+08
7	ea92595b-0c01-4b71-b017-24af94274c3f	SDS	{"raw_score": 50, "standard_score": 62, "depression_level": "\\u8f7b\\u5ea6\\u6291\\u90c1", "interpretation": "\\u60a8\\u7684\\u6807\\u51c6\\u5206\\u4e3a62\\uff0c\\u5c5e\\u4e8e\\u8f7b\\u5ea6\\u6291\\u90c1\\u3002\\u5efa\\u8bae\\u4fdd\\u6301\\u826f\\u597d\\u7684\\u751f\\u6d3b\\u4e60\\u60ef\\uff0c\\u9002\\u5f53\\u8c03\\u6574\\u5fc3\\u6001\\uff0c\\u5fc5\\u8981\\u65f6\\u53ef\\u5bfb\\u6c42\\u4e13\\u4e1a\\u5e2e\\u52a9\\u3002"}		2025-06-20 18:59:41.007544+08
8	ea92595b-0c01-4b71-b017-24af94274c3f	MBTI	{"mbti_type": "INFP", "description": "\\u7406\\u60f3\\u4e3b\\u4e49\\uff0c\\u5bf9\\u4e8e\\u81ea\\u5df1\\u7684\\u4ef7\\u503c\\u89c2\\u548c\\u81ea\\u5df1\\u89c9\\u5f97\\u91cd\\u8981\\u7684\\u4eba\\u975e\\u5e38\\u5fe0\\u8bda\\u3002\\u5e0c\\u671b\\u5916\\u90e8\\u7684\\u751f\\u6d3b\\u548c\\u81ea\\u5df1\\u5185\\u5fc3\\u7684\\u4ef7\\u503c\\u89c2\\u662f\\u7edf\\u4e00\\u7684\\u3002\\u597d\\u5947\\u5fc3\\u91cd\\uff0c\\u5f88\\u5feb\\u80fd\\u770b\\u5230\\u4e8b\\u60c5\\u7684\\u53ef\\u80fd\\u6027\\uff0c\\u80fd\\u6210\\u4e3a\\u5b9e\\u73b0\\u60f3\\u6cd5\\u7684\\u50ac\\u5316\\u5242\\u3002\\u5bfb\\u6c42\\u7406\\u89e3\\u522b\\u4eba\\u548c\\u5e2e\\u52a9\\u4ed6\\u4eec\\u5b9e\\u73b0\\u6f5c\\u80fd\\u3002\\u9002\\u5e94\\u529b\\u5f3a\\uff0c\\u7075\\u6d3b\\uff0c\\u5584\\u4e8e\\u627f\\u53d7\\uff0c\\u9664\\u975e\\u662f\\u6709\\u6096\\u4e8e\\u81ea\\u5df1\\u7684\\u4ef7\\u503c\\u89c2\\u7684\\u3002"}		2025-06-20 18:59:49.635285+08
\.


--
-- Data for Name: user_buffers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_buffers (id, user_id, conversation_id, role, content, message_id, parent_message_id, created_at, model_metadata) FROM stdin;
34	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	代码总是报错是什么原因	msg_40	msg_39	2025-06-18 20:47:43.412883+08	
35	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	代码总是报错是什么原因	msg_41	msg_40	2025-06-18 20:50:09.197179+08	
36	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	您好，我注意到您在技术问题上遇到了一些困扰。作为心理陪伴助手，我观察到重复询问同一个技术问题可能反映出某种焦虑情绪。🤔\n\n从心理学角度看，当我们在某个领域反复遇到障碍时，往往会产生"习得性无助感"。建议您可以：\n1. 先暂停5分钟进行深呼吸（4-7-8呼吸法）\n2. 将大问题拆解成小步骤\n\n您愿意和我聊聊写代码时具体的情绪体验吗？比如当看到报错信息时，身体会有什么感觉？🧐	msg_42	msg_41	2025-06-18 20:50:16.274249+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
37	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	写代码的时候想着快点写完	msg_43	msg_42	2025-06-18 20:51:21.077596+08	
31	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	您好，我是心研助手。作为心理学与AI结合的研究型智能体，我会以专业视角陪伴您探索情绪需求。	msg_31	\N	2025-06-18 20:41:03.822744+08	
32	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	你会编程吗	msg_38	msg_37	2025-06-18 20:41:22.369881+08	
33	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	你好呀	msg_39	msg_38	2025-06-18 20:43:39.281932+08	
38	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	我注意到您提到"想快点写完"时，这种时间压力可能触发了心理学上的"时间紧迫感"现象⏳。根据耶克斯-多德森定律，适度的紧迫感能提升效率，但过度时反而会影响认知功能。\n\n建议您可以：\n1. 尝试"番茄工作法"（25分钟专注+5分钟休息）\n2. 用便利贴把"完美主义"暂时贴到墙上（具象化抽离技巧）\n\n您平时会用什么方式来缓解这种编程时的急切感呢？比如听某种特定音乐或调整工作环境？🎵\n\n（运用心理学理论解释现象，提供两种具体干预方案，最后以开放式提问引导自我觉察）	msg_44	msg_43	2025-06-18 20:51:29.971741+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
39	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	是这样的	msg_45	msg_44	2025-06-18 21:22:28.662898+08	{}
40	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	是这样的	msg_46	msg_45	2025-06-18 21:25:02.807384+08	{}
41	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	我理解您对当前状态的认同，这反映出您开始觉察到自己的编程状态了🧠。从心理学角度看，这种"是这样的"的确认回应，其实是一种重要的自我认知信号。\n\n让我们尝试用"认知解离"技术来观察这个状态：\n1️⃣ 想象把"急切感"放在房间的沙发上（具象化技术）\n2️⃣ 问自己："如果朋友处在这种状态，我会给他什么建议？"（视角转换法）\n\n您注意到"想快点写完"这个念头时，身体哪个部位最先感受到紧张呢？🤔（引导躯体觉察）\n\n（运用具象化+视角转换两种技术，保持1提问+2支持点的专业结构）	msg_47	msg_46	2025-06-18 21:25:12.522172+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
42	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	哎呀好烦	msg_48	msg_47	2025-06-18 21:45:01.94373+08	{}
43	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	哎呀好烦	msg_49	msg_48	2025-06-18 21:47:46.743975+08	{}
44	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	哎呀好烦	msg_50	msg_49	2025-06-18 21:49:21.530622+08	{}
45	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	user	哎呀好烦	msg_51	msg_50	2025-06-18 21:51:24.915482+08	{}
46	ea92595b-0c01-4b71-b017-24af94274c3f	conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad	ai	我注意到您反复表达了"好烦"的情绪，这种重复实际上是一种很重要的心理信号📶。从情绪调节理论来看，重复表达往往是深层压力需要释放的表现。\n\n让我们试试"情绪容器"技术：\n1️⃣ 想象面前有个透明容器，把"烦"的情绪具象成某种颜色/质地的物体（情绪外化）\n2️⃣ 观察这个物体在容器中的变化（静观技术）\n\n您愿意描述一下这个"烦"在身体里是什么感觉吗？比如是发热的、沉重的还是刺痛的？🧠（引导躯体化觉察）\n\n（运用情绪外化+静观技术，保持专业陪伴结构）	msg_52	msg_51	2025-06-18 21:51:34.985685+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
47	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	ai	您好，我是心研助手。作为心理学与AI结合的研究型智能体，我会以专业视角陪伴您探索情绪需求。	msg_53	\N	2025-06-22 19:34:12.695642+08	{}
48	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	user	我现在很不舒服	msg_54	msg_53	2025-06-22 19:34:46.849631+08	{}
49	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	ai	我注意到您用了"很不舒服"这样的整体性描述（情绪识别），这种弥散性的负面感受确实会让人困扰（共情反馈）✨\n\n从心理学角度看，我们可以先做个简单的"情绪定位"（专业引导）：\n1. 这种不适更多是身体上的紧绷/疼痛，还是心理上的压抑/焦虑？（区分生理心理）\n2. 如果用0-10分评估强度，您现在的感受大概在哪个区间？（量化评估）\n\n根据压力研究的ABC理论，当我们能清晰定义不适的维度时（认知心理学应用），往往就找到了调节的突破口🌱\n\n您愿意选择一个维度先聊聊吗？（给予掌控感）	msg_55	msg_54	2025-06-22 19:34:56.547513+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
50	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	user	目前比较焦虑	msg_56	msg_55	2025-06-22 19:36:32.291098+08	{}
51	ea92595b-0c01-4b71-b017-24af94274c3f	conv_1cfc8250-c546-4004-b8d1-99ece9434fcc	ai	我理解您正在经历焦虑的困扰（情绪确认），这种感受就像大脑的预警系统被过度激活（神经心理学解释）🧠\n\n根据焦虑认知模型（专业理论引用），我们可以从两个层面来梳理：\n1. 触发因素：最近是否遇到某些具体事件引发了这种焦虑？（情境探索）\n2. 身体信号：您注意到心跳加快/呼吸变化等生理反应了吗？（身心联结引导）\n\n研究显示（数据支持），当人们能用具体词汇描述焦虑时（如"截止日期焦虑"vs"社交场合焦虑"），焦虑强度平均会降低23%（Journal of Anxiety Disorders, 2021）📊\n\n您愿意尝试用1-2个关键词来形容当前的焦虑类型吗？（结构化引导）	msg_57	msg_56	2025-06-22 19:36:40.910642+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
52	ea92595b-0c01-4b71-b017-24af94274c3f	conv_ba257234-a094-4c8a-8fb2-27a6a900c94f	ai	您好，我是心研助手。作为心理学与AI结合的研究型智能体，我会以专业视角陪伴您探索情绪需求。	msg_58	\N	2025-06-22 21:02:01.08245+08	{}
53	ea92595b-0c01-4b71-b017-24af94274c3f	conv_ba257234-a094-4c8a-8fb2-27a6a900c94f	user	好吧	msg_59	msg_58	2025-06-22 21:02:59.094961+08	{}
54	ea92595b-0c01-4b71-b017-24af94274c3f	conv_ba257234-a094-4c8a-8fb2-27a6a900c94f	ai	我注意到您似乎有些欲言又止（情绪觉察）。或许我们可以先聊聊您今天的状态？就像调整显微镜焦距一样（专业比喻🔬），慢慢找到最适合交流的切入点。\n\n您更倾向于：\n1. 分享具体的生活事件\n2. 探讨某种模糊的感受\n3. 寻求应对压力的方法建议\n\n（采用选项式提问降低表达压力，同时保持专业框架）	msg_60	msg_59	2025-06-22 21:03:05.044892+08	{"model_name": "deepseek-ai/DeepSeek-V3", "temperature": 0.5}
\.


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.users (phone, password_hash, email, created_at, id, avatar_url, nickname, gender, signature, long_term_memory) FROM stdin;
16603067314	$2b$12$Zdg0t6NUNDixqRIJN28OZ.5ecPf15XvzKgvqVybRdTsZvtyxXda6u	456@qq.com	2025-05-25 11:37:26.915868+08	2d680754-f1f2-43b2-8d63-af34397009da	static/avatar/2d680754-f1f2-43b2-8d63-af34397009da.jpg	新昵称	女         	个性签名测试	{}
15836654003	$2b$12$KvXYndTPzOtX0Ag9k6UUGeBKre.rKL/9KCzAlp0r9yIGkvkOBuUd.	789@qq.com	2025-06-20 15:20:55.846647+08	4bdec59e-74c5-4227-8e5f-fe2f5ab454c5	static/avatar/4bdec59e-74c5-4227-8e5f-fe2f5ab454c5.jpg	新昵称	女         	个性签名测试	{}
19801296231	$2b$12$88VRTtBJ3X0Im/.72W4Qy.oQHTPXLXc468yJY0JGWjmXT.co7.AQy	123@qq.com	2025-05-08 14:20:33.854015+08	ea92595b-0c01-4b71-b017-24af94274c3f	\N	冬瓜瓜	男         	，，，	```json\n{\n    "性格": "内向且敏感",\n    "核心困扰": "社交焦虑和人际关系困扰",\n    "干预方法": "认知行为疗法(CBT)和渐进式社交暴露",\n    "阶段性结论": "来访者同意尝试逐步参与社交活动并记录情绪反应",\n    "补充信息": {\n        "conv_e7c53e0f-80f9-46fa-9cdb-dea258fe20ad": "首次咨询时表现出强烈的自我否定倾向",\n        "conv_1cfc8250-c546-4004-b8d1-99ece9434fcc": "开始认识到自己的非理性信念"\n    }\n}\n```
\.


--
-- Name: conversation_records_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.conversation_records_id_seq', 60, true);


--
-- Name: emotion_records_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.emotion_records_id_seq', 2, true);


--
-- Name: psychological_assessment_records_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.psychological_assessment_records_id_seq', 8, true);


--
-- Name: user_buffers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.user_buffers_id_seq', 54, true);


--
-- Name: conversation_records conversation_records_message_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversation_records
    ADD CONSTRAINT conversation_records_message_id_key UNIQUE (message_id);


--
-- Name: conversation_records conversation_records_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversation_records
    ADD CONSTRAINT conversation_records_pkey PRIMARY KEY (id);


--
-- Name: conversations conversations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_pkey PRIMARY KEY (id);


--
-- Name: emotion_records emotion_records_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.emotion_records
    ADD CONSTRAINT emotion_records_pkey PRIMARY KEY (id);


--
-- Name: mood_records mood_records_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mood_records
    ADD CONSTRAINT mood_records_pkey PRIMARY KEY (id);


--
-- Name: psychological_assessment_records psychological_assessment_records_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.psychological_assessment_records
    ADD CONSTRAINT psychological_assessment_records_pkey PRIMARY KEY (id);


--
-- Name: user_buffers user_buffers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_buffers
    ADD CONSTRAINT user_buffers_pkey PRIMARY KEY (id);


--
-- Name: users users_id_uuid_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_id_uuid_key UNIQUE (id);


--
-- Name: users users_phone_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_phone_key UNIQUE (phone);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: idx_assessment_time; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_assessment_time ON public.psychological_assessment_records USING btree (assessment_time);


--
-- Name: idx_emotion_records_created_at; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_emotion_records_created_at ON public.emotion_records USING btree (created_at);


--
-- Name: idx_emotion_records_user_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_emotion_records_user_id ON public.emotion_records USING btree (user_id);


--
-- Name: idx_message_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_message_id ON public.conversation_records USING btree (message_id);


--
-- Name: idx_user_assessment_name; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_user_assessment_name ON public.psychological_assessment_records USING btree (user_id, assessment_name);


--
-- Name: ix_user_buffers_conversation_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ix_user_buffers_conversation_id ON public.user_buffers USING btree (conversation_id);


--
-- Name: ix_user_buffers_user_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ix_user_buffers_user_id ON public.user_buffers USING btree (user_id);


--
-- Name: emotion_records emotion_records_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.emotion_records
    ADD CONSTRAINT emotion_records_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: conversations fk_conversations_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT fk_conversations_user_id FOREIGN KEY (user_id) REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: conversation_records fk_records_conversation_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversation_records
    ADD CONSTRAINT fk_records_conversation_id FOREIGN KEY (conversation_id) REFERENCES public.conversations(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: conversation_records fk_records_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversation_records
    ADD CONSTRAINT fk_records_user_id FOREIGN KEY (user_id) REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: mood_records fk_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mood_records
    ADD CONSTRAINT fk_user FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: psychological_assessment_records fk_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.psychological_assessment_records
    ADD CONSTRAINT fk_user_id FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: user_buffers user_buffers_conversation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_buffers
    ADD CONSTRAINT user_buffers_conversation_id_fkey FOREIGN KEY (conversation_id) REFERENCES public.conversations(id);


--
-- Name: user_buffers user_buffers_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_buffers
    ADD CONSTRAINT user_buffers_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- PostgreSQL database dump complete
--

